-- ==============================================================================================

CREATE OR REPLACE PROCEDURE ZOEDEVOPS.ZOEPRC_IF_REMOTE_EXEC_SQL(iv_json_sql IN OUT varchar2, iv_db_link IN VARCHAR2)
--AUTHID CURRENT_USER	
-- Created in 2019.06.25 by polarbears
-- Copyright (c) 20xx, CHINA and/or affiliates.
-- All rights reserved.
--	Name:
-- 		zoeprc_exec_sql.sql
--	Description:
-- 		
--  Relation:
--      zoeUtility
--	Notes:
--		
--	修改 - （年-月-日） - 描述
--  

 AS
 lv_remote_sql      VARCHAR2(32767);
BEGIN
    lv_remote_sql :='BEGIN ZOEDEVOPS.ZOEPRC_EXEC_SQL@'||iv_db_link||'(:1); END;';
	EXECUTE IMMEDIATE lv_remote_sql using IN OUT iv_json_sql;
EXCEPTION
    WHEN OTHERS THEN
        RAISE;
    
END ZOEPRC_IF_REMOTE_EXEC_SQL;
/
